2015/1/4
alter table house_info add column building_type_id int;
2015/1/9
alter table user add column is_activate varchar(20);
2015/1/22
alter table building_type add column building_area varchar(50);
alter table building_type add column extra_area varchar(50);
2015/1/30
alter table building_type add column price varchar(255);
2015/2/9
alter table orders add column alipay_trade_no varchar(255);
2015/09/08
alter table reserve add column date varchar(255);
2015/10/08
alter table user add column userInfo_id INT(12);
alter table user_info modify column gender VARCHAR(6);
2015/10/14
alter table my_house add column usable TINYINT(1) DEFAULT '1';
alter table my_house add column exchange_house TINYINT(1) DEFAULT '0';
alter table house_base add column themes varchar(255);
2015/10/26
alter table house_info add column title varchar(255);
alter table house_info add column title_image_id int;
alter table house_week add column description varchar(1000);

2015-11-08
alter table house_info drop column  house_info_status;

alter table my_house drop column exchange_pool_status ;
alter table my_house add column my_house_status varchar(12);
2015/11/09
alter table house_week add column total_num int(255) DEFAULT 0;
alter table house_week add column sold_num int(255) DEFAULT 0;
alter table house_info add column developers varchar(255);
alter table house_info add column permits varchar(255);
alter table house_info add column province int;
alter table house_info add column city int;
alter table house_info add column fine_room TINYINT(1) DEFAULT '0';
2015/11/11
alter table house_info drop column fine_theme;
alter table house_base add column fine_theme TINYINT(1) DEFAULT '0';
2015/11/12
alter table orders add column address_id int;
2015/11/16
alter table house_info add column district int;
alter table house_info add column area VARCHAR(255);
alter table rent add column customer VARCHAR(50);
alter table rent add column phone_num VARCHAR(50);
alter table rent add column description_for_cus VARCHAR(255);

2015/11/21
alter table rent add column person_num VARCHAR(255);
alter table rent add column notice_way TINYINT(1) DEFAULT '0';
alter table assignment  add column assigner_id INT;


2015/12/09
alter table rent add column user_rent  VARCHAR(20);
alter table rent add column user_id  INT;

2015/12/15
alter table my_house add column days  int default 0;
alter table house_base add column sort  int default 0;

2015/12/29
alter table reserve_time add column status VARCHAR(20);



